USE [HomestayWebDB]
GO
/****** Object:  StoredProcedure [dbo].[Store_Posts_DeletePost]    Script Date: 11/26/2012 17:30:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROC [dbo].[Store_Posts_DeletePost]
(
	@PostID int
)
AS
UPDATE Posts SET IsDeleted = CAST(1 AS BIT)
WHERE PostID = @PostID